package ph.com.gs3.formalistics.model.tables;

public class FormDocumentsUpdateTable extends AbstractDataTable {

	public static final String TAG = FormDocumentsUpdateTable.class.getSimpleName();

	// table name
	public static final String NAME = "Forms_Documents_Update";

	public static final String COL_FORM_ID = "form_id";
	public static final String COL_DOCUMENTS_LAST_UPDATED = "documents_last_update_date";
	public static final String COL_DOCUMENT_UPDATE_COUNT = "update_count";

	@Override
	public String[] getTableColumns() {
		return new String[] { COL_FORM_ID, COL_DOCUMENTS_LAST_UPDATED, COL_DOCUMENT_UPDATE_COUNT };
	}

	@Override
	protected String getCreateTableQuery() {
		// @formatter:off
		return "CREATE TABLE " + NAME + "(" 
				+ COL_FORM_ID 					+ " INTEGER PRIMARY KEY AUTOINCREMENT, "
		        + COL_DOCUMENTS_LAST_UPDATED 	+ " TEXT NOT NULL, " 
				+ COL_DOCUMENT_UPDATE_COUNT 	+ " TEXT NOT NULL" 
				+ "); ";
		// @formatter:on
	}

	@Override
	protected String getTableName() {
		return NAME;
	}

}
